CREATE TABLE STREET

(GID int IDENTITY(1,1) NOT NULL CONSTRAINT PK_STREET_GID PRIMARY KEY,

NAME varchar(50) NULL,

STREET_CAT varchar(50) NULL,

GEOM geometry NULL)

--Sample insert statements

INSERT INTO STREET VALUES ('HIGHWAY 101', 'HIGHWAY', geometry::STLineFromText('LINESTRING(1 5, 21 35)',0))